<%@page contentType="text/html; charset=utf-8" language="java" errorPage="" %>
<%@page import="btsm.bean.page,java.sql.*"%>
<%!ResultSet rs;%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>管井维护</TITLE>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<LINK href="Admin_Style.css" type=text/css rel=stylesheet>
</HEAD>
<%
    page mypage = new page("tubewell", "1");//更改
	
	String strbsSign = request.getParameter("bsSign");
	
		String strFilter = request.getParameter("txtFilter");
		String strUTF8Filter = "";
		if(strFilter == null || strFilter.equals("null"))
			strFilter = "";
		else
			strUTF8Filter = new String(strFilter.getBytes("ISO8859-1"), "UTF-8");	

    String jspName = request.getRequestURI();
    jspName = jspName.substring(jspName.lastIndexOf("/") + 1);		
    String strToPage = request.getParameter("ToPage");		
	
	String strsnid = (String) request.getAttribute("snid");
	String strValues[] = new String[35];
	String idtmp;
%>

<BODY style="margin:2; overflow:auto">
<script type="text/javascript" src="./datePicker/WdatePicker.js"></script>
<script>
	function btnRinsertS(){
		document.Jz_myform.seraction.value="serinsertsimple";
		document.Jz_myform.submit();
	}
	function btnModifyU(){
		document.Jz_myform.seraction.value="sermod";
		document.Jz_myform.submit();
	}
</script>
<SCRIPT>
    function tjsj(x){
        document.Jz_myform.snid.value=x;
		document.Jz_myform.seraction.value="serdel";
        if(confirm('确认要删除流水号为'+x+'的记录吗？'))
        	document.Jz_myform.submit();     
    }

    function tjsjx(x){
        document.Jz_myform.snid.value=x;
		document.Jz_myform.seraction.value="sermodp";
        document.Jz_myform.submit();
    }
</SCRIPT>
<script>
function tst(obj0,obj1,obj2){
obj0.style.border="1 "+obj1+" solid";
obj0.style.background=obj2;
}
</script>
<script>
function genQuery(){
	frmQuery.bsSign.value = "1";
    frmQuery.submit();
}
</script>
<TABLE class="border" cellSpacing=1 cellPadding=2 width="100%" border=0>
  <!--位置区域数据开始-->
  <TBODY>
    <!--*********搜索工具条开始*****************-->
  <FORM name="frmQuery" action="nnmd_tubewell.jsp" method="post">
    <TR class=tdbg onMouseOver="this.className='tdbgmouseover'" onMouseOut="this.className='tdbg'" align=middle>
      <TD colspan="13"><input type="hidden" name="snid" id="snid" value="<%=strsnid%>">
        <p>
          <input type="hidden" name="bsSign" value="0">
          查  询：
          <input type="text" name="txtFilter" size="20" style="width: 159; height: 20" class=text2d onBlur="checkQuote(this.value,this)" onKeyDown="if(event.keyCode==13){genQuery()};" value="<%=strUTF8Filter%>">
          &nbsp;&nbsp;&nbsp;
          <input type="button" value=" 搜索 " name="btnQuery" style="width: 40; height: 20" class=tx_button onClick="genQuery()" onMouseOver="tst(this,'blue','#ffffff')" onMouseOut="tst(this,'black','#e8e7fe')">
          &nbsp;&nbsp;&nbsp;
          <input type="checkbox" title="模糊匹配" checked="checked"　name="chkBlur">
      模糊匹配 </p></TD>
    </TR>
  </FORM>
  <!--*********搜索工具条结束*****************-->
  <TR>
    <!--位置区域名称表单开始-->
    <FORM name="frmInterconsys" action="nnmd_tubewell.jsp" method="post">
      <TD width="155">
      <TBODY id=Tabs>
        <!--位置区域名称列表表头开始-->
      <TR class=title align=middle height=22>
          <TD align="center">流水号</TD>
          <TD width="181" align="center">管井编码</TD>
          <TD width="276" align="center">管井名称</TD>
          <TD width="121" align="center">经度</TD>
          <TD width="121" align="center">纬度</TD>
          <TD width="121" align="center">井类别</TD>
		  <TD width="121" align="center">井类型</TD>
		  <TD width="121" align="center">人井结构</TD>
		  <TD width="121" align="center">井底长</TD>
		  <TD width="121" align="center">井底宽</TD>
          <TD colspan="2"><p align="center">操作</p></TD>
        </TR>
        <!--位置区域名称列表表头结束-->
        <!--位置区域名称列表记录循环代码开始-->
        <% 
          if (strbsSign == null || strbsSign.equals("0") || strFilter == null || strFilter.equals("")) {
            rs = mypage.myQuery(request,response,1,10);
        } else {
            rs = mypage.interconBFQuery(request, response,1, 10, strFilter);
        }
		
        while(rs.next())
        {
%>
      <TR class=tdbg onMouseOver="this.className='tdbgmouseover'" onMouseOut="this.className='tdbg'" align=middle>
          <TD><%=rs.getString(1)%></TD>
          <TD><%=rs.getString(2)%></TD>
          <TD><%=rs.getString(3)%></TD>
          <TD><%=rs.getString(4)%></TD>
		  <TD><%=rs.getString(5)%></TD>
		  <TD><%=rs.getString(6)%></TD>
		  <TD><%=rs.getString(7)%></TD>
		  <TD><%=rs.getString(8)%></TD>
		  <TD><%=rs.getString(9)%></TD>
		  <TD><%=rs.getString(10)%></TD>
          <TD width="111"><a href="javascript:tjsjx('<%=rs.getString(1)%>')">修改</a></TD>
          <TD width="114"><a href="javascript:tjsj('<%=rs.getString(1)%>')">删除</a></TD>
        </TR>
        <%
	 		idtmp = rs.getString(1);
			if(strsnid == null)
	        {
    	        strsnid = rs.getString(1);
        	}
			if(strsnid.equalsIgnoreCase(idtmp))
			{
				for(int i = 0; i < 35; ++i)
				{
						strValues[i] = rs.getString(i+1);
				}
			}	
		}
        String footer = mypage.PageFooter();
%>
        <% 
	rs.close();
%>
        <!--位置区域名称列表记录循环代码结束-->
    </form>
  <TR class=tdbg onMouseOver="this.className='tdbgmouseover'" onMouseOut="this.className='tdbg'" align=middle>
    <TD colspan="12"><div class="article-bottom">
        <div class="pages">
          <%out.println(footer);%>
        </div>
      </div>
      <!--mainWrapper -->
      <div id="footer">
        <div id="innerFooter"></div>
    </div></TD>
    <!--位置区域名称表单结束-->
  </TR>
  </TBODY>
  
  <!--位置区域数据结束-->
</TABLE>
<TABLE class=border cellSpacing=1 cellPadding=2 width="100%" align=center border=0>
        <FORM name="Jz_myform" action="ser_tubewell" method="post">
          <!--更改-->
          <!--添加数据表单开始-->
          <TBODY id=Tabs>
			<tr class=tdbg>
              	<TD class=tdbg5 height="26">流水号：</TD>
           	  <TD height="26"><%=strValues[0]%><input type="hidden" name="T1" size="46" class=text2d value="<%=strValues[1]%>" maxlength="24"></TD>
              	<TD class=tdbg5 height="26"></TD>
           	  <TD height="26"></TD>
			</tr >
			<tr class=tdbg>
              	<TD class=tdbg5 height="26">管井编码：</TD>
           	  <TD height="26"><input type="text" name="T1" size="46" class=text2d value="<%=strValues[1]%>" maxlength="24"></TD>
				<TD height="26" class=tdbg5>管井名称：</TD>
           	<TD height="26"><input type="text" name="T1" size="60" class=text2d value="<%=strValues[2]%>" maxlength="128" onBlur="checkQuote(this.value,this)"></tr>
			<tr class=tdbg>
              	<TD class=tdbg5 height="26">原有名称：</TD>
           	  <TD height="26"><input type="text" name="T1" size="46" class=text2d value="<%=strValues[3]%>" maxlength="24"></TD>
				<TD height="26" class=tdbg5>&nbsp;</TD>
           	    <TD height="26">
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">经度：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[4]%>">              </TD>
			  <TD class=tdbg5 height="26">纬度：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[5]%>">              </TD>
			</tr>
            <tr class=tdbg>
              <TD class=tdbg5 height="26">井类别：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[6]%>">              </TD>
			  <TD class=tdbg5 height="26">井类型：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[7]%>">              </TD>
			</tr>
            <tr class=tdbg>
              <TD class=tdbg5 height="26">人井结构：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[8]%>">              </TD>
			  <TD class=tdbg5 height="26">井底长：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[9]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">井度宽：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[10]%>">              </TD>
			  <TD class=tdbg5 height="26">净空高：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[11]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">路边距：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[12]%>">              </TD>
			  <TD class=tdbg5 height="26">井底深度：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[13]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">上覆厚：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[14]%>">              </TD>
			  <TD class=tdbg5 height="26">多眼井：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[15]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">所属市州：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[16]%>">              </TD>
			  <TD class=tdbg5 height="26">所属县区：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[17]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">道路名称：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[18]%>">              </TD>
			  <TD class=tdbg5 height="26">设施状态：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[19]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">产权性质：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[20]%>">              </TD>
			  <TD class=tdbg5 height="26">是否有电子锁：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[21]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">井盖材质：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[22]%>">              </TD>
			  <TD class=tdbg5 height="26">井盖形状：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[23]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">井盖规格：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[24]%>">              </TD>
			  <TD class=tdbg5 height="26">所属工程：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[25]%>"></TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">施工单位：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[26]%>">              </TD>
			  <TD class=tdbg5 height="26">监理单位：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[27]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">维护单位：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[28]%>">              </TD>
			  <TD class=tdbg5 height="26">主建单位：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[29]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">参建单位：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[30]%>">              </TD>
			  <TD class=tdbg5 height="26">固定资产编号：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[31]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">采集时间：</TD>
              <TD height="26"><input type="text" name="T1" size="12" class="Wdate" value="<%=strValues[32]%>" id="d122" onFocus="WdatePicker({isShowWeek:true,onpicked:function() {$dp.$('d122_1').value=$dp.cal.getP('W','W');$dp.$('d122_2').value=$dp.cal.getP('W','WW');}})"/></TD>
			  <TD class=tdbg5 height="26">所属管理区：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[33]%>">              </TD>
			</tr>
			<tr class=tdbg>
              <TD class=tdbg5 height="26">租用单位：</TD>
              <TD height="26"><input type="text" name="T1" class=text2d value="<%=strValues[34]%>">              </TD>
			  <TD class=tdbg5 height="26">&nbsp;</TD>
              <TD height="26">&nbsp;</TD>
			</tr>
            <TR class=tdbg>
              <TD class=tdbg5 height="51" colspan="5"><p align="center">
                  <input type="hidden" name="filesnames" value=<%=jspName%>>
                  <input type="hidden" name="seraction" value="sermod">
                  <input type="hidden" name="snid" id="snid" value="<%=strsnid%>">
                  <input type="hidden" name="tToPage"  id="tToPage" value="<%=strToPage%>">
                  <input type="button" value="增加" name="btnInsert" style="width: 72; height: 25" class=tx_button onMouseOver="tst(this,'blue','#ffffff')" onMouseOut="tst(this,'black','#e8e7fe')" onClick="btnRinsertS();">
                  &nbsp;&nbsp;&nbsp;&nbsp;
                  <input type="button" value="修改保存" name="JzB1" style="width: 72; height: 25" class=tx_button onMouseOver="tst(this,'blue','#ffffff')" onMouseOut="tst(this,'black','#e8e7fe')" onClick="btnModifyU();">
                  &nbsp;&nbsp;&nbsp;&nbsp;
                  <input type="reset" value="重置" name="JzB2" style="width: 72; height: 25" class=tx_button onMouseOver="tst(this,'blue','#ffffff')" onMouseOut="tst(this,'black','#e8e7fe')">
                  &nbsp;&nbsp;&nbsp;&nbsp;</TD>
            </TR>
          </TBODY>
        </FORM>
        <% 
		mypage.dbConClose();
        %>
</TABLE>
</BODY>
